SQL: ==== ALL datas: ---------- select * from databaseName.tableName; Particular column: ------------------- select Id,Name from databaseName.tableName; ------------------------------------------------------------------------------------------- Step 1: ======= url= "jdbc:db_type://ipaddress:port/db_name" username="root" password="admin" query="select * from world.city" step 2: [Load the driver] ====== Class.forName("com.mysql.jdbc.Driver"); Step 3: [Create a connection] ======= Connection con = DriverManager.getConnection(url,username,password); Step 4: [create statement object for query] ======= Statement st = con.createStatement(); Step 5: [execute the query] ======= ResultSet rs = st.executeQuery(query);